use hsh
create table Realty(property_id int identity(10,1) not null primary key,
 [Type] varchar(15),[Size] int,Price int,Rooms int,Baths int,Garage int,
Street varchar(30),City varchar(15),State varchar(15),Zip int,Status varchar(30),
Comments varchar(100),Picture varchar(30)) 




use hsh
insert Realty(
 [Type] ,[Size] ,Price,Rooms ,Baths ,Garage ,
Street ,City ,Zip ,Status ,
Comments ,Picture) 
values
('condo',23400,500000,3,1,1,'534 Grand Ave.','Dreamsville','NV',875422,'for sale','big back yard','on file')



CREATE PROC get_author1 @au_lname varchar(11) 
AS SELECT au_id, au_fname, au_lname
FROM authors 
WHERE au_lname=@au_lname